CREATE VIEW [dbo].[vDonationsDistribution]
   AS
    SELECT    
        MAX(TransactionDate)as Date,  
        MAX(ID) as ID,  
        MAX(ORIGINATING_TRANS_NUM) as OriginalTransaction,  
        MAX(ActivityType) as GiftType,  
        SUM(Amount) as Amount,
        MAX(SourceSystem) as SourceSystem,
        MAX(SolicitorId) as SolicitorId,     
        MAX(UserField4) as RequestCode,
        MAX(ProductCode) as ProductCode,  
        MAX(EntityCode) as FundCode,
        MAX(SourceCode) as AppealCode ,
        MAX(CampaignCode) as CampaignCode  
            FROM vBoCsActivity
                GROUP BY ORIGINATING_TRANS_NUM

GO
GRANT REFERENCES ON  [dbo].[vDonationsDistribution] TO [IMIS]
GRANT SELECT ON  [dbo].[vDonationsDistribution] TO [IMIS]
GRANT INSERT ON  [dbo].[vDonationsDistribution] TO [IMIS]
GRANT DELETE ON  [dbo].[vDonationsDistribution] TO [IMIS]
GRANT UPDATE ON  [dbo].[vDonationsDistribution] TO [IMIS]
GO